package com.itic.system.order.order.persistence.model;

import com.itic.appbase.framework.common.persistence.model.BaseExample;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderExample extends BaseExample {
    /**
    
     *
     * @mbggenerated
     */
    protected String orderByClause;

    /**
    
     *
     * @mbggenerated
     */
    protected boolean distinct;

    /**
    
     *
     * @mbggenerated
     */
    protected List<Criteria> oredCriteria;

    /**
    
     *
     * @mbggenerated
     */
    public OrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
    
     *
     * @mbggenerated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
    
     *
     * @mbggenerated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
    
     *
     * @mbggenerated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
    
     *
     * @mbggenerated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
    
     *
     * @mbggenerated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class corresponds to the database table t_hpp_order
     *
     * @mbggenerated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIsNull() {
            addCriterion("IS_EFFECTIVE is null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIsNotNull() {
            addCriterion("IS_EFFECTIVE is not null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveEqualTo(String value) {
            addCriterion("IS_EFFECTIVE =", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotEqualTo(String value) {
            addCriterion("IS_EFFECTIVE <>", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveGreaterThan(String value) {
            addCriterion("IS_EFFECTIVE >", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveGreaterThanOrEqualTo(String value) {
            addCriterion("IS_EFFECTIVE >=", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLessThan(String value) {
            addCriterion("IS_EFFECTIVE <", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLessThanOrEqualTo(String value) {
            addCriterion("IS_EFFECTIVE <=", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLike(String value) {
            addCriterion("IS_EFFECTIVE like", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotLike(String value) {
            addCriterion("IS_EFFECTIVE not like", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIn(List<String> values) {
            addCriterion("IS_EFFECTIVE in", values, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotIn(List<String> values) {
            addCriterion("IS_EFFECTIVE not in", values, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveBetween(String value1, String value2) {
            addCriterion("IS_EFFECTIVE between", value1, value2, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotBetween(String value1, String value2) {
            addCriterion("IS_EFFECTIVE not between", value1, value2, "isEffective");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNull() {
            addCriterion("ORG_CODE is null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNotNull() {
            addCriterion("ORG_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeEqualTo(String value) {
            addCriterion("ORG_CODE =", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotEqualTo(String value) {
            addCriterion("ORG_CODE <>", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThan(String value) {
            addCriterion("ORG_CODE >", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_CODE >=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThan(String value) {
            addCriterion("ORG_CODE <", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThanOrEqualTo(String value) {
            addCriterion("ORG_CODE <=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLike(String value) {
            addCriterion("ORG_CODE like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotLike(String value) {
            addCriterion("ORG_CODE not like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIn(List<String> values) {
            addCriterion("ORG_CODE in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotIn(List<String> values) {
            addCriterion("ORG_CODE not in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeBetween(String value1, String value2) {
            addCriterion("ORG_CODE between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotBetween(String value1, String value2) {
            addCriterion("ORG_CODE not between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andReorderIsNull() {
            addCriterion("REORDER is null");
            return (Criteria) this;
        }

        public Criteria andReorderIsNotNull() {
            addCriterion("REORDER is not null");
            return (Criteria) this;
        }

        public Criteria andReorderEqualTo(Integer value) {
            addCriterion("REORDER =", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotEqualTo(Integer value) {
            addCriterion("REORDER <>", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderGreaterThan(Integer value) {
            addCriterion("REORDER >", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderGreaterThanOrEqualTo(Integer value) {
            addCriterion("REORDER >=", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderLessThan(Integer value) {
            addCriterion("REORDER <", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderLessThanOrEqualTo(Integer value) {
            addCriterion("REORDER <=", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderIn(List<Integer> values) {
            addCriterion("REORDER in", values, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotIn(List<Integer> values) {
            addCriterion("REORDER not in", values, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderBetween(Integer value1, Integer value2) {
            addCriterion("REORDER between", value1, value2, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotBetween(Integer value1, Integer value2) {
            addCriterion("REORDER not between", value1, value2, "reorder");
            return (Criteria) this;
        }

        public Criteria andNoteIsNull() {
            addCriterion("note is null");
            return (Criteria) this;
        }

        public Criteria andNoteIsNotNull() {
            addCriterion("note is not null");
            return (Criteria) this;
        }

        public Criteria andNoteEqualTo(String value) {
            addCriterion("note =", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotEqualTo(String value) {
            addCriterion("note <>", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThan(String value) {
            addCriterion("note >", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThanOrEqualTo(String value) {
            addCriterion("note >=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThan(String value) {
            addCriterion("note <", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThanOrEqualTo(String value) {
            addCriterion("note <=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLike(String value) {
            addCriterion("note like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotLike(String value) {
            addCriterion("note not like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteIn(List<String> values) {
            addCriterion("note in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotIn(List<String> values) {
            addCriterion("note not in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteBetween(String value1, String value2) {
            addCriterion("note between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotBetween(String value1, String value2) {
            addCriterion("note not between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("ORDER_NO is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("ORDER_NO is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("ORDER_NO =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("ORDER_NO <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("ORDER_NO >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_NO >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("ORDER_NO <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("ORDER_NO <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("ORDER_NO like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("ORDER_NO not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("ORDER_NO in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("ORDER_NO not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("ORDER_NO between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("ORDER_NO not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceIsNull() {
            addCriterion("ORIGINAL_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceIsNotNull() {
            addCriterion("ORIGINAL_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceEqualTo(Double value) {
            addCriterion("ORIGINAL_PRICE =", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceNotEqualTo(Double value) {
            addCriterion("ORIGINAL_PRICE <>", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceGreaterThan(Double value) {
            addCriterion("ORIGINAL_PRICE >", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("ORIGINAL_PRICE >=", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceLessThan(Double value) {
            addCriterion("ORIGINAL_PRICE <", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceLessThanOrEqualTo(Double value) {
            addCriterion("ORIGINAL_PRICE <=", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceIn(List<Double> values) {
            addCriterion("ORIGINAL_PRICE in", values, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceNotIn(List<Double> values) {
            addCriterion("ORIGINAL_PRICE not in", values, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceBetween(Double value1, Double value2) {
            addCriterion("ORIGINAL_PRICE between", value1, value2, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceNotBetween(Double value1, Double value2) {
            addCriterion("ORIGINAL_PRICE not between", value1, value2, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceIsNull() {
            addCriterion("COLLAGE_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andCollagePriceIsNotNull() {
            addCriterion("COLLAGE_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andCollagePriceEqualTo(Double value) {
            addCriterion("COLLAGE_PRICE =", value, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceNotEqualTo(Double value) {
            addCriterion("COLLAGE_PRICE <>", value, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceGreaterThan(Double value) {
            addCriterion("COLLAGE_PRICE >", value, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceGreaterThanOrEqualTo(Double value) {
            addCriterion("COLLAGE_PRICE >=", value, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceLessThan(Double value) {
            addCriterion("COLLAGE_PRICE <", value, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceLessThanOrEqualTo(Double value) {
            addCriterion("COLLAGE_PRICE <=", value, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceIn(List<Double> values) {
            addCriterion("COLLAGE_PRICE in", values, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceNotIn(List<Double> values) {
            addCriterion("COLLAGE_PRICE not in", values, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceBetween(Double value1, Double value2) {
            addCriterion("COLLAGE_PRICE between", value1, value2, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andCollagePriceNotBetween(Double value1, Double value2) {
            addCriterion("COLLAGE_PRICE not between", value1, value2, "collagePrice");
            return (Criteria) this;
        }

        public Criteria andReciveNameIsNull() {
            addCriterion("RECIVE_NAME is null");
            return (Criteria) this;
        }

        public Criteria andReciveNameIsNotNull() {
            addCriterion("RECIVE_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andReciveNameEqualTo(String value) {
            addCriterion("RECIVE_NAME =", value, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameNotEqualTo(String value) {
            addCriterion("RECIVE_NAME <>", value, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameGreaterThan(String value) {
            addCriterion("RECIVE_NAME >", value, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameGreaterThanOrEqualTo(String value) {
            addCriterion("RECIVE_NAME >=", value, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameLessThan(String value) {
            addCriterion("RECIVE_NAME <", value, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameLessThanOrEqualTo(String value) {
            addCriterion("RECIVE_NAME <=", value, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameLike(String value) {
            addCriterion("RECIVE_NAME like", value, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameNotLike(String value) {
            addCriterion("RECIVE_NAME not like", value, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameIn(List<String> values) {
            addCriterion("RECIVE_NAME in", values, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameNotIn(List<String> values) {
            addCriterion("RECIVE_NAME not in", values, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameBetween(String value1, String value2) {
            addCriterion("RECIVE_NAME between", value1, value2, "reciveName");
            return (Criteria) this;
        }

        public Criteria andReciveNameNotBetween(String value1, String value2) {
            addCriterion("RECIVE_NAME not between", value1, value2, "reciveName");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneIsNull() {
            addCriterion("RECIVE_PHONE is null");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneIsNotNull() {
            addCriterion("RECIVE_PHONE is not null");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneEqualTo(String value) {
            addCriterion("RECIVE_PHONE =", value, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneNotEqualTo(String value) {
            addCriterion("RECIVE_PHONE <>", value, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneGreaterThan(String value) {
            addCriterion("RECIVE_PHONE >", value, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneGreaterThanOrEqualTo(String value) {
            addCriterion("RECIVE_PHONE >=", value, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneLessThan(String value) {
            addCriterion("RECIVE_PHONE <", value, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneLessThanOrEqualTo(String value) {
            addCriterion("RECIVE_PHONE <=", value, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneLike(String value) {
            addCriterion("RECIVE_PHONE like", value, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneNotLike(String value) {
            addCriterion("RECIVE_PHONE not like", value, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneIn(List<String> values) {
            addCriterion("RECIVE_PHONE in", values, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneNotIn(List<String> values) {
            addCriterion("RECIVE_PHONE not in", values, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneBetween(String value1, String value2) {
            addCriterion("RECIVE_PHONE between", value1, value2, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andRecivePhoneNotBetween(String value1, String value2) {
            addCriterion("RECIVE_PHONE not between", value1, value2, "recivePhone");
            return (Criteria) this;
        }

        public Criteria andFeeIsNull() {
            addCriterion("FEE is null");
            return (Criteria) this;
        }

        public Criteria andFeeIsNotNull() {
            addCriterion("FEE is not null");
            return (Criteria) this;
        }

        public Criteria andFeeEqualTo(Double value) {
            addCriterion("FEE =", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotEqualTo(Double value) {
            addCriterion("FEE <>", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThan(Double value) {
            addCriterion("FEE >", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThanOrEqualTo(Double value) {
            addCriterion("FEE >=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThan(Double value) {
            addCriterion("FEE <", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThanOrEqualTo(Double value) {
            addCriterion("FEE <=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeIn(List<Double> values) {
            addCriterion("FEE in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotIn(List<Double> values) {
            addCriterion("FEE not in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeBetween(Double value1, Double value2) {
            addCriterion("FEE between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotBetween(Double value1, Double value2) {
            addCriterion("FEE not between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdIsNull() {
            addCriterion("BUY_USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdIsNotNull() {
            addCriterion("BUY_USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdEqualTo(String value) {
            addCriterion("BUY_USER_ID =", value, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdNotEqualTo(String value) {
            addCriterion("BUY_USER_ID <>", value, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdGreaterThan(String value) {
            addCriterion("BUY_USER_ID >", value, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("BUY_USER_ID >=", value, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdLessThan(String value) {
            addCriterion("BUY_USER_ID <", value, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdLessThanOrEqualTo(String value) {
            addCriterion("BUY_USER_ID <=", value, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdLike(String value) {
            addCriterion("BUY_USER_ID like", value, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdNotLike(String value) {
            addCriterion("BUY_USER_ID not like", value, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdIn(List<String> values) {
            addCriterion("BUY_USER_ID in", values, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdNotIn(List<String> values) {
            addCriterion("BUY_USER_ID not in", values, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdBetween(String value1, String value2) {
            addCriterion("BUY_USER_ID between", value1, value2, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andBuyUserIdNotBetween(String value1, String value2) {
            addCriterion("BUY_USER_ID not between", value1, value2, "buyUserId");
            return (Criteria) this;
        }

        public Criteria andCollageIdIsNull() {
            addCriterion("COLLAGE_ID is null");
            return (Criteria) this;
        }

        public Criteria andCollageIdIsNotNull() {
            addCriterion("COLLAGE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCollageIdEqualTo(String value) {
            addCriterion("COLLAGE_ID =", value, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdNotEqualTo(String value) {
            addCriterion("COLLAGE_ID <>", value, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdGreaterThan(String value) {
            addCriterion("COLLAGE_ID >", value, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdGreaterThanOrEqualTo(String value) {
            addCriterion("COLLAGE_ID >=", value, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdLessThan(String value) {
            addCriterion("COLLAGE_ID <", value, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdLessThanOrEqualTo(String value) {
            addCriterion("COLLAGE_ID <=", value, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdLike(String value) {
            addCriterion("COLLAGE_ID like", value, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdNotLike(String value) {
            addCriterion("COLLAGE_ID not like", value, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdIn(List<String> values) {
            addCriterion("COLLAGE_ID in", values, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdNotIn(List<String> values) {
            addCriterion("COLLAGE_ID not in", values, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdBetween(String value1, String value2) {
            addCriterion("COLLAGE_ID between", value1, value2, "collageId");
            return (Criteria) this;
        }

        public Criteria andCollageIdNotBetween(String value1, String value2) {
            addCriterion("COLLAGE_ID not between", value1, value2, "collageId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdIsNull() {
            addCriterion("SELLER_USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdIsNotNull() {
            addCriterion("SELLER_USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdEqualTo(String value) {
            addCriterion("SELLER_USER_ID =", value, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdNotEqualTo(String value) {
            addCriterion("SELLER_USER_ID <>", value, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdGreaterThan(String value) {
            addCriterion("SELLER_USER_ID >", value, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("SELLER_USER_ID >=", value, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdLessThan(String value) {
            addCriterion("SELLER_USER_ID <", value, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdLessThanOrEqualTo(String value) {
            addCriterion("SELLER_USER_ID <=", value, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdLike(String value) {
            addCriterion("SELLER_USER_ID like", value, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdNotLike(String value) {
            addCriterion("SELLER_USER_ID not like", value, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdIn(List<String> values) {
            addCriterion("SELLER_USER_ID in", values, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdNotIn(List<String> values) {
            addCriterion("SELLER_USER_ID not in", values, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdBetween(String value1, String value2) {
            addCriterion("SELLER_USER_ID between", value1, value2, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andSellerUserIdNotBetween(String value1, String value2) {
            addCriterion("SELLER_USER_ID not between", value1, value2, "sellerUserId");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageIsNull() {
            addCriterion("LEAVING_MESSAGE is null");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageIsNotNull() {
            addCriterion("LEAVING_MESSAGE is not null");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageEqualTo(String value) {
            addCriterion("LEAVING_MESSAGE =", value, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageNotEqualTo(String value) {
            addCriterion("LEAVING_MESSAGE <>", value, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageGreaterThan(String value) {
            addCriterion("LEAVING_MESSAGE >", value, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageGreaterThanOrEqualTo(String value) {
            addCriterion("LEAVING_MESSAGE >=", value, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageLessThan(String value) {
            addCriterion("LEAVING_MESSAGE <", value, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageLessThanOrEqualTo(String value) {
            addCriterion("LEAVING_MESSAGE <=", value, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageLike(String value) {
            addCriterion("LEAVING_MESSAGE like", value, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageNotLike(String value) {
            addCriterion("LEAVING_MESSAGE not like", value, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageIn(List<String> values) {
            addCriterion("LEAVING_MESSAGE in", values, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageNotIn(List<String> values) {
            addCriterion("LEAVING_MESSAGE not in", values, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageBetween(String value1, String value2) {
            addCriterion("LEAVING_MESSAGE between", value1, value2, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andLeavingMessageNotBetween(String value1, String value2) {
            addCriterion("LEAVING_MESSAGE not between", value1, value2, "leavingMessage");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodIsNull() {
            addCriterion("DELIVER_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodIsNotNull() {
            addCriterion("DELIVER_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodEqualTo(String value) {
            addCriterion("DELIVER_METHOD =", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodNotEqualTo(String value) {
            addCriterion("DELIVER_METHOD <>", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodGreaterThan(String value) {
            addCriterion("DELIVER_METHOD >", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodGreaterThanOrEqualTo(String value) {
            addCriterion("DELIVER_METHOD >=", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodLessThan(String value) {
            addCriterion("DELIVER_METHOD <", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodLessThanOrEqualTo(String value) {
            addCriterion("DELIVER_METHOD <=", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodLike(String value) {
            addCriterion("DELIVER_METHOD like", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodNotLike(String value) {
            addCriterion("DELIVER_METHOD not like", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodIn(List<String> values) {
            addCriterion("DELIVER_METHOD in", values, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodNotIn(List<String> values) {
            addCriterion("DELIVER_METHOD not in", values, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodBetween(String value1, String value2) {
            addCriterion("DELIVER_METHOD between", value1, value2, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodNotBetween(String value1, String value2) {
            addCriterion("DELIVER_METHOD not between", value1, value2, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andSkuNameIsNull() {
            addCriterion("SKU_NAME is null");
            return (Criteria) this;
        }

        public Criteria andSkuNameIsNotNull() {
            addCriterion("SKU_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andSkuNameEqualTo(String value) {
            addCriterion("SKU_NAME =", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameNotEqualTo(String value) {
            addCriterion("SKU_NAME <>", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameGreaterThan(String value) {
            addCriterion("SKU_NAME >", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameGreaterThanOrEqualTo(String value) {
            addCriterion("SKU_NAME >=", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameLessThan(String value) {
            addCriterion("SKU_NAME <", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameLessThanOrEqualTo(String value) {
            addCriterion("SKU_NAME <=", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameLike(String value) {
            addCriterion("SKU_NAME like", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameNotLike(String value) {
            addCriterion("SKU_NAME not like", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameIn(List<String> values) {
            addCriterion("SKU_NAME in", values, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameNotIn(List<String> values) {
            addCriterion("SKU_NAME not in", values, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameBetween(String value1, String value2) {
            addCriterion("SKU_NAME between", value1, value2, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameNotBetween(String value1, String value2) {
            addCriterion("SKU_NAME not between", value1, value2, "skuName");
            return (Criteria) this;
        }

        public Criteria andTitleIsNull() {
            addCriterion("TITLE is null");
            return (Criteria) this;
        }

        public Criteria andTitleIsNotNull() {
            addCriterion("TITLE is not null");
            return (Criteria) this;
        }

        public Criteria andTitleEqualTo(String value) {
            addCriterion("TITLE =", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotEqualTo(String value) {
            addCriterion("TITLE <>", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThan(String value) {
            addCriterion("TITLE >", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThanOrEqualTo(String value) {
            addCriterion("TITLE >=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThan(String value) {
            addCriterion("TITLE <", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThanOrEqualTo(String value) {
            addCriterion("TITLE <=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLike(String value) {
            addCriterion("TITLE like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotLike(String value) {
            addCriterion("TITLE not like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleIn(List<String> values) {
            addCriterion("TITLE in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotIn(List<String> values) {
            addCriterion("TITLE not in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleBetween(String value1, String value2) {
            addCriterion("TITLE between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotBetween(String value1, String value2) {
            addCriterion("TITLE not between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andQrCodeIsNull() {
            addCriterion("QR_CODE is null");
            return (Criteria) this;
        }

        public Criteria andQrCodeIsNotNull() {
            addCriterion("QR_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andQrCodeEqualTo(String value) {
            addCriterion("QR_CODE =", value, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeNotEqualTo(String value) {
            addCriterion("QR_CODE <>", value, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeGreaterThan(String value) {
            addCriterion("QR_CODE >", value, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeGreaterThanOrEqualTo(String value) {
            addCriterion("QR_CODE >=", value, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeLessThan(String value) {
            addCriterion("QR_CODE <", value, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeLessThanOrEqualTo(String value) {
            addCriterion("QR_CODE <=", value, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeLike(String value) {
            addCriterion("QR_CODE like", value, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeNotLike(String value) {
            addCriterion("QR_CODE not like", value, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeIn(List<String> values) {
            addCriterion("QR_CODE in", values, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeNotIn(List<String> values) {
            addCriterion("QR_CODE not in", values, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeBetween(String value1, String value2) {
            addCriterion("QR_CODE between", value1, value2, "qrCode");
            return (Criteria) this;
        }

        public Criteria andQrCodeNotBetween(String value1, String value2) {
            addCriterion("QR_CODE not between", value1, value2, "qrCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeIsNull() {
            addCriterion("VIRTUAL_CODE is null");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeIsNotNull() {
            addCriterion("VIRTUAL_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeEqualTo(String value) {
            addCriterion("VIRTUAL_CODE =", value, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeNotEqualTo(String value) {
            addCriterion("VIRTUAL_CODE <>", value, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeGreaterThan(String value) {
            addCriterion("VIRTUAL_CODE >", value, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeGreaterThanOrEqualTo(String value) {
            addCriterion("VIRTUAL_CODE >=", value, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeLessThan(String value) {
            addCriterion("VIRTUAL_CODE <", value, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeLessThanOrEqualTo(String value) {
            addCriterion("VIRTUAL_CODE <=", value, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeLike(String value) {
            addCriterion("VIRTUAL_CODE like", value, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeNotLike(String value) {
            addCriterion("VIRTUAL_CODE not like", value, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeIn(List<String> values) {
            addCriterion("VIRTUAL_CODE in", values, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeNotIn(List<String> values) {
            addCriterion("VIRTUAL_CODE not in", values, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeBetween(String value1, String value2) {
            addCriterion("VIRTUAL_CODE between", value1, value2, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andVirtualCodeNotBetween(String value1, String value2) {
            addCriterion("VIRTUAL_CODE not between", value1, value2, "virtualCode");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("PROVINCE is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("PROVINCE is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("PROVINCE =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("PROVINCE <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("PROVINCE >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("PROVINCE >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("PROVINCE <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("PROVINCE <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("PROVINCE like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("PROVINCE not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("PROVINCE in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("PROVINCE not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("PROVINCE between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("PROVINCE not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("CITY is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("CITY is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("CITY =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("CITY <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("CITY >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("CITY >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("CITY <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("CITY <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("CITY like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("CITY not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("CITY in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("CITY not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("CITY between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("CITY not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andRegionIsNull() {
            addCriterion("REGION is null");
            return (Criteria) this;
        }

        public Criteria andRegionIsNotNull() {
            addCriterion("REGION is not null");
            return (Criteria) this;
        }

        public Criteria andRegionEqualTo(String value) {
            addCriterion("REGION =", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotEqualTo(String value) {
            addCriterion("REGION <>", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionGreaterThan(String value) {
            addCriterion("REGION >", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionGreaterThanOrEqualTo(String value) {
            addCriterion("REGION >=", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionLessThan(String value) {
            addCriterion("REGION <", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionLessThanOrEqualTo(String value) {
            addCriterion("REGION <=", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionLike(String value) {
            addCriterion("REGION like", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotLike(String value) {
            addCriterion("REGION not like", value, "region");
            return (Criteria) this;
        }

        public Criteria andRegionIn(List<String> values) {
            addCriterion("REGION in", values, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotIn(List<String> values) {
            addCriterion("REGION not in", values, "region");
            return (Criteria) this;
        }

        public Criteria andRegionBetween(String value1, String value2) {
            addCriterion("REGION between", value1, value2, "region");
            return (Criteria) this;
        }

        public Criteria andRegionNotBetween(String value1, String value2) {
            addCriterion("REGION not between", value1, value2, "region");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIsNull() {
            addCriterion("PROVINCE_ID is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIsNotNull() {
            addCriterion("PROVINCE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceIdEqualTo(String value) {
            addCriterion("PROVINCE_ID =", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotEqualTo(String value) {
            addCriterion("PROVINCE_ID <>", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdGreaterThan(String value) {
            addCriterion("PROVINCE_ID >", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdGreaterThanOrEqualTo(String value) {
            addCriterion("PROVINCE_ID >=", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLessThan(String value) {
            addCriterion("PROVINCE_ID <", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLessThanOrEqualTo(String value) {
            addCriterion("PROVINCE_ID <=", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLike(String value) {
            addCriterion("PROVINCE_ID like", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotLike(String value) {
            addCriterion("PROVINCE_ID not like", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIn(List<String> values) {
            addCriterion("PROVINCE_ID in", values, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotIn(List<String> values) {
            addCriterion("PROVINCE_ID not in", values, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdBetween(String value1, String value2) {
            addCriterion("PROVINCE_ID between", value1, value2, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotBetween(String value1, String value2) {
            addCriterion("PROVINCE_ID not between", value1, value2, "provinceId");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNull() {
            addCriterion("CITY_ID is null");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNotNull() {
            addCriterion("CITY_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCityIdEqualTo(String value) {
            addCriterion("CITY_ID =", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotEqualTo(String value) {
            addCriterion("CITY_ID <>", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThan(String value) {
            addCriterion("CITY_ID >", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThanOrEqualTo(String value) {
            addCriterion("CITY_ID >=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThan(String value) {
            addCriterion("CITY_ID <", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThanOrEqualTo(String value) {
            addCriterion("CITY_ID <=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLike(String value) {
            addCriterion("CITY_ID like", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotLike(String value) {
            addCriterion("CITY_ID not like", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdIn(List<String> values) {
            addCriterion("CITY_ID in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotIn(List<String> values) {
            addCriterion("CITY_ID not in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdBetween(String value1, String value2) {
            addCriterion("CITY_ID between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotBetween(String value1, String value2) {
            addCriterion("CITY_ID not between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andRegionIdIsNull() {
            addCriterion("REGION_ID is null");
            return (Criteria) this;
        }

        public Criteria andRegionIdIsNotNull() {
            addCriterion("REGION_ID is not null");
            return (Criteria) this;
        }

        public Criteria andRegionIdEqualTo(String value) {
            addCriterion("REGION_ID =", value, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdNotEqualTo(String value) {
            addCriterion("REGION_ID <>", value, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdGreaterThan(String value) {
            addCriterion("REGION_ID >", value, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdGreaterThanOrEqualTo(String value) {
            addCriterion("REGION_ID >=", value, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdLessThan(String value) {
            addCriterion("REGION_ID <", value, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdLessThanOrEqualTo(String value) {
            addCriterion("REGION_ID <=", value, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdLike(String value) {
            addCriterion("REGION_ID like", value, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdNotLike(String value) {
            addCriterion("REGION_ID not like", value, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdIn(List<String> values) {
            addCriterion("REGION_ID in", values, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdNotIn(List<String> values) {
            addCriterion("REGION_ID not in", values, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdBetween(String value1, String value2) {
            addCriterion("REGION_ID between", value1, value2, "regionId");
            return (Criteria) this;
        }

        public Criteria andRegionIdNotBetween(String value1, String value2) {
            addCriterion("REGION_ID not between", value1, value2, "regionId");
            return (Criteria) this;
        }

        public Criteria andActualPayIsNull() {
            addCriterion("ACTUAL_PAY is null");
            return (Criteria) this;
        }

        public Criteria andActualPayIsNotNull() {
            addCriterion("ACTUAL_PAY is not null");
            return (Criteria) this;
        }

        public Criteria andActualPayEqualTo(Double value) {
            addCriterion("ACTUAL_PAY =", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayNotEqualTo(Double value) {
            addCriterion("ACTUAL_PAY <>", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayGreaterThan(Double value) {
            addCriterion("ACTUAL_PAY >", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayGreaterThanOrEqualTo(Double value) {
            addCriterion("ACTUAL_PAY >=", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayLessThan(Double value) {
            addCriterion("ACTUAL_PAY <", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayLessThanOrEqualTo(Double value) {
            addCriterion("ACTUAL_PAY <=", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayIn(List<Double> values) {
            addCriterion("ACTUAL_PAY in", values, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayNotIn(List<Double> values) {
            addCriterion("ACTUAL_PAY not in", values, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayBetween(Double value1, Double value2) {
            addCriterion("ACTUAL_PAY between", value1, value2, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayNotBetween(Double value1, Double value2) {
            addCriterion("ACTUAL_PAY not between", value1, value2, "actualPay");
            return (Criteria) this;
        }

        public Criteria andPayMethodIsNull() {
            addCriterion("PAY_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andPayMethodIsNotNull() {
            addCriterion("PAY_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andPayMethodEqualTo(String value) {
            addCriterion("PAY_METHOD =", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotEqualTo(String value) {
            addCriterion("PAY_METHOD <>", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodGreaterThan(String value) {
            addCriterion("PAY_METHOD >", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_METHOD >=", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLessThan(String value) {
            addCriterion("PAY_METHOD <", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLessThanOrEqualTo(String value) {
            addCriterion("PAY_METHOD <=", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLike(String value) {
            addCriterion("PAY_METHOD like", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotLike(String value) {
            addCriterion("PAY_METHOD not like", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodIn(List<String> values) {
            addCriterion("PAY_METHOD in", values, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotIn(List<String> values) {
            addCriterion("PAY_METHOD not in", values, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodBetween(String value1, String value2) {
            addCriterion("PAY_METHOD between", value1, value2, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotBetween(String value1, String value2) {
            addCriterion("PAY_METHOD not between", value1, value2, "payMethod");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("STATE is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLike(String value) {
            addCriterion("STATE like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotLike(String value) {
            addCriterion("STATE not like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<String> values) {
            addCriterion("STATE in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andIsBeliveIsNull() {
            addCriterion("IS_BELIVE is null");
            return (Criteria) this;
        }

        public Criteria andIsBeliveIsNotNull() {
            addCriterion("IS_BELIVE is not null");
            return (Criteria) this;
        }

        public Criteria andIsBeliveEqualTo(String value) {
            addCriterion("IS_BELIVE =", value, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveNotEqualTo(String value) {
            addCriterion("IS_BELIVE <>", value, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveGreaterThan(String value) {
            addCriterion("IS_BELIVE >", value, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveGreaterThanOrEqualTo(String value) {
            addCriterion("IS_BELIVE >=", value, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveLessThan(String value) {
            addCriterion("IS_BELIVE <", value, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveLessThanOrEqualTo(String value) {
            addCriterion("IS_BELIVE <=", value, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveLike(String value) {
            addCriterion("IS_BELIVE like", value, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveNotLike(String value) {
            addCriterion("IS_BELIVE not like", value, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveIn(List<String> values) {
            addCriterion("IS_BELIVE in", values, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveNotIn(List<String> values) {
            addCriterion("IS_BELIVE not in", values, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveBetween(String value1, String value2) {
            addCriterion("IS_BELIVE between", value1, value2, "isBelive");
            return (Criteria) this;
        }

        public Criteria andIsBeliveNotBetween(String value1, String value2) {
            addCriterion("IS_BELIVE not between", value1, value2, "isBelive");
            return (Criteria) this;
        }

        public Criteria andCollageTypeIsNull() {
            addCriterion("COLLAGE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCollageTypeIsNotNull() {
            addCriterion("COLLAGE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCollageTypeEqualTo(String value) {
            addCriterion("COLLAGE_TYPE =", value, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeNotEqualTo(String value) {
            addCriterion("COLLAGE_TYPE <>", value, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeGreaterThan(String value) {
            addCriterion("COLLAGE_TYPE >", value, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeGreaterThanOrEqualTo(String value) {
            addCriterion("COLLAGE_TYPE >=", value, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeLessThan(String value) {
            addCriterion("COLLAGE_TYPE <", value, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeLessThanOrEqualTo(String value) {
            addCriterion("COLLAGE_TYPE <=", value, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeLike(String value) {
            addCriterion("COLLAGE_TYPE like", value, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeNotLike(String value) {
            addCriterion("COLLAGE_TYPE not like", value, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeIn(List<String> values) {
            addCriterion("COLLAGE_TYPE in", values, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeNotIn(List<String> values) {
            addCriterion("COLLAGE_TYPE not in", values, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeBetween(String value1, String value2) {
            addCriterion("COLLAGE_TYPE between", value1, value2, "collageType");
            return (Criteria) this;
        }

        public Criteria andCollageTypeNotBetween(String value1, String value2) {
            addCriterion("COLLAGE_TYPE not between", value1, value2, "collageType");
            return (Criteria) this;
        }

        public Criteria andCountIsNull() {
            addCriterion("COUNT is null");
            return (Criteria) this;
        }

        public Criteria andCountIsNotNull() {
            addCriterion("COUNT is not null");
            return (Criteria) this;
        }

        public Criteria andCountEqualTo(Integer value) {
            addCriterion("COUNT =", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotEqualTo(Integer value) {
            addCriterion("COUNT <>", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountGreaterThan(Integer value) {
            addCriterion("COUNT >", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("COUNT >=", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLessThan(Integer value) {
            addCriterion("COUNT <", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLessThanOrEqualTo(Integer value) {
            addCriterion("COUNT <=", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountIn(List<Integer> values) {
            addCriterion("COUNT in", values, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotIn(List<Integer> values) {
            addCriterion("COUNT not in", values, "count");
            return (Criteria) this;
        }

        public Criteria andCountBetween(Integer value1, Integer value2) {
            addCriterion("COUNT between", value1, value2, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotBetween(Integer value1, Integer value2) {
            addCriterion("COUNT not between", value1, value2, "count");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdIsNull() {
            addCriterion("SKU_PROPERTY_ID is null");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdIsNotNull() {
            addCriterion("SKU_PROPERTY_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdEqualTo(String value) {
            addCriterion("SKU_PROPERTY_ID =", value, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdNotEqualTo(String value) {
            addCriterion("SKU_PROPERTY_ID <>", value, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdGreaterThan(String value) {
            addCriterion("SKU_PROPERTY_ID >", value, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdGreaterThanOrEqualTo(String value) {
            addCriterion("SKU_PROPERTY_ID >=", value, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdLessThan(String value) {
            addCriterion("SKU_PROPERTY_ID <", value, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdLessThanOrEqualTo(String value) {
            addCriterion("SKU_PROPERTY_ID <=", value, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdLike(String value) {
            addCriterion("SKU_PROPERTY_ID like", value, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdNotLike(String value) {
            addCriterion("SKU_PROPERTY_ID not like", value, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdIn(List<String> values) {
            addCriterion("SKU_PROPERTY_ID in", values, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdNotIn(List<String> values) {
            addCriterion("SKU_PROPERTY_ID not in", values, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdBetween(String value1, String value2) {
            addCriterion("SKU_PROPERTY_ID between", value1, value2, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andSkuPropertyIdNotBetween(String value1, String value2) {
            addCriterion("SKU_PROPERTY_ID not between", value1, value2, "skuPropertyId");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("ORDER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("ORDER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(String value) {
            addCriterion("ORDER_TYPE =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(String value) {
            addCriterion("ORDER_TYPE <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(String value) {
            addCriterion("ORDER_TYPE >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_TYPE >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(String value) {
            addCriterion("ORDER_TYPE <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("ORDER_TYPE <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLike(String value) {
            addCriterion("ORDER_TYPE like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotLike(String value) {
            addCriterion("ORDER_TYPE not like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<String> values) {
            addCriterion("ORDER_TYPE in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<String> values) {
            addCriterion("ORDER_TYPE not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(String value1, String value2) {
            addCriterion("ORDER_TYPE between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(String value1, String value2) {
            addCriterion("ORDER_TYPE not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andExpressIdIsNull() {
            addCriterion("EXPRESS_ID is null");
            return (Criteria) this;
        }

        public Criteria andExpressIdIsNotNull() {
            addCriterion("EXPRESS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andExpressIdEqualTo(String value) {
            addCriterion("EXPRESS_ID =", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdNotEqualTo(String value) {
            addCriterion("EXPRESS_ID <>", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdGreaterThan(String value) {
            addCriterion("EXPRESS_ID >", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdGreaterThanOrEqualTo(String value) {
            addCriterion("EXPRESS_ID >=", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdLessThan(String value) {
            addCriterion("EXPRESS_ID <", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdLessThanOrEqualTo(String value) {
            addCriterion("EXPRESS_ID <=", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdLike(String value) {
            addCriterion("EXPRESS_ID like", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdNotLike(String value) {
            addCriterion("EXPRESS_ID not like", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdIn(List<String> values) {
            addCriterion("EXPRESS_ID in", values, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdNotIn(List<String> values) {
            addCriterion("EXPRESS_ID not in", values, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdBetween(String value1, String value2) {
            addCriterion("EXPRESS_ID between", value1, value2, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdNotBetween(String value1, String value2) {
            addCriterion("EXPRESS_ID not between", value1, value2, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressNameIsNull() {
            addCriterion("EXPRESS_NAME is null");
            return (Criteria) this;
        }

        public Criteria andExpressNameIsNotNull() {
            addCriterion("EXPRESS_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andExpressNameEqualTo(String value) {
            addCriterion("EXPRESS_NAME =", value, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameNotEqualTo(String value) {
            addCriterion("EXPRESS_NAME <>", value, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameGreaterThan(String value) {
            addCriterion("EXPRESS_NAME >", value, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameGreaterThanOrEqualTo(String value) {
            addCriterion("EXPRESS_NAME >=", value, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameLessThan(String value) {
            addCriterion("EXPRESS_NAME <", value, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameLessThanOrEqualTo(String value) {
            addCriterion("EXPRESS_NAME <=", value, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameLike(String value) {
            addCriterion("EXPRESS_NAME like", value, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameNotLike(String value) {
            addCriterion("EXPRESS_NAME not like", value, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameIn(List<String> values) {
            addCriterion("EXPRESS_NAME in", values, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameNotIn(List<String> values) {
            addCriterion("EXPRESS_NAME not in", values, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameBetween(String value1, String value2) {
            addCriterion("EXPRESS_NAME between", value1, value2, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNameNotBetween(String value1, String value2) {
            addCriterion("EXPRESS_NAME not between", value1, value2, "expressName");
            return (Criteria) this;
        }

        public Criteria andExpressNoIsNull() {
            addCriterion("EXPRESS_NO is null");
            return (Criteria) this;
        }

        public Criteria andExpressNoIsNotNull() {
            addCriterion("EXPRESS_NO is not null");
            return (Criteria) this;
        }

        public Criteria andExpressNoEqualTo(String value) {
            addCriterion("EXPRESS_NO =", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotEqualTo(String value) {
            addCriterion("EXPRESS_NO <>", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoGreaterThan(String value) {
            addCriterion("EXPRESS_NO >", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoGreaterThanOrEqualTo(String value) {
            addCriterion("EXPRESS_NO >=", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoLessThan(String value) {
            addCriterion("EXPRESS_NO <", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoLessThanOrEqualTo(String value) {
            addCriterion("EXPRESS_NO <=", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoLike(String value) {
            addCriterion("EXPRESS_NO like", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotLike(String value) {
            addCriterion("EXPRESS_NO not like", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoIn(List<String> values) {
            addCriterion("EXPRESS_NO in", values, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotIn(List<String> values) {
            addCriterion("EXPRESS_NO not in", values, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoBetween(String value1, String value2) {
            addCriterion("EXPRESS_NO between", value1, value2, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotBetween(String value1, String value2) {
            addCriterion("EXPRESS_NO not between", value1, value2, "expressNo");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageIsNull() {
            addCriterion("IS_TRADE_COLLAGE is null");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageIsNotNull() {
            addCriterion("IS_TRADE_COLLAGE is not null");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageEqualTo(String value) {
            addCriterion("IS_TRADE_COLLAGE =", value, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageNotEqualTo(String value) {
            addCriterion("IS_TRADE_COLLAGE <>", value, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageGreaterThan(String value) {
            addCriterion("IS_TRADE_COLLAGE >", value, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageGreaterThanOrEqualTo(String value) {
            addCriterion("IS_TRADE_COLLAGE >=", value, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageLessThan(String value) {
            addCriterion("IS_TRADE_COLLAGE <", value, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageLessThanOrEqualTo(String value) {
            addCriterion("IS_TRADE_COLLAGE <=", value, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageLike(String value) {
            addCriterion("IS_TRADE_COLLAGE like", value, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageNotLike(String value) {
            addCriterion("IS_TRADE_COLLAGE not like", value, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageIn(List<String> values) {
            addCriterion("IS_TRADE_COLLAGE in", values, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageNotIn(List<String> values) {
            addCriterion("IS_TRADE_COLLAGE not in", values, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageBetween(String value1, String value2) {
            addCriterion("IS_TRADE_COLLAGE between", value1, value2, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andIsTradeCollageNotBetween(String value1, String value2) {
            addCriterion("IS_TRADE_COLLAGE not between", value1, value2, "isTradeCollage");
            return (Criteria) this;
        }

        public Criteria andSendMethodIsNull() {
            addCriterion("SEND_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andSendMethodIsNotNull() {
            addCriterion("SEND_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andSendMethodEqualTo(String value) {
            addCriterion("SEND_METHOD =", value, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodNotEqualTo(String value) {
            addCriterion("SEND_METHOD <>", value, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodGreaterThan(String value) {
            addCriterion("SEND_METHOD >", value, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodGreaterThanOrEqualTo(String value) {
            addCriterion("SEND_METHOD >=", value, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodLessThan(String value) {
            addCriterion("SEND_METHOD <", value, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodLessThanOrEqualTo(String value) {
            addCriterion("SEND_METHOD <=", value, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodLike(String value) {
            addCriterion("SEND_METHOD like", value, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodNotLike(String value) {
            addCriterion("SEND_METHOD not like", value, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodIn(List<String> values) {
            addCriterion("SEND_METHOD in", values, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodNotIn(List<String> values) {
            addCriterion("SEND_METHOD not in", values, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodBetween(String value1, String value2) {
            addCriterion("SEND_METHOD between", value1, value2, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andSendMethodNotBetween(String value1, String value2) {
            addCriterion("SEND_METHOD not between", value1, value2, "sendMethod");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeIsNull() {
            addCriterion("CONFIRM_RECIVE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeIsNotNull() {
            addCriterion("CONFIRM_RECIVE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeEqualTo(Date value) {
            addCriterion("CONFIRM_RECIVE_TIME =", value, "confirmReciveTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeNotEqualTo(Date value) {
            addCriterion("CONFIRM_RECIVE_TIME <>", value, "confirmReciveTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeGreaterThan(Date value) {
            addCriterion("CONFIRM_RECIVE_TIME >", value, "confirmReciveTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CONFIRM_RECIVE_TIME >=", value, "confirmReciveTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeLessThan(Date value) {
            addCriterion("CONFIRM_RECIVE_TIME <", value, "confirmReciveTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeLessThanOrEqualTo(Date value) {
            addCriterion("CONFIRM_RECIVE_TIME <=", value, "confirmReciveTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeIn(List<Date> values) {
            addCriterion("CONFIRM_RECIVE_TIME in", values, "confirmReciveTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeNotIn(List<Date> values) {
            addCriterion("CONFIRM_RECIVE_TIME not in", values, "confirmReciveTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeBetween(Date value1, Date value2) {
            addCriterion("CONFIRM_RECIVE_TIME between", value1, value2, "confirmReciveTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReciveTimeNotBetween(Date value1, Date value2) {
            addCriterion("CONFIRM_RECIVE_TIME not between", value1, value2, "confirmReciveTime");
            return (Criteria) this;
        }
    }

    /**
     * This class corresponds to the database table t_hpp_order
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class corresponds to the database table t_hpp_order
     *
     * @mbggenerated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value) {
            super();
            this.condition = condition;
            this.value = value;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.betweenValue = true;
        }
    }
}